How to: Create a new database using the Database Wizard.
Solution:
Select a built-in template on which to base the new database, specify the name and the location of the new database, click 'Create' to start the Database Wizard, and then follow the instructions displayed on the screen.
1) Select the built-in template to use for the new database:
a) Do one of the following:
1] If Microsoft Access has not been started:
2] If Microsoft Access is already open, select the 'File' menu and select 'New Database...'. (The New dialog box appears.)
b) Click the 'Databases' tab.
the Databases tab
c) Select the template on which to base the new database. (The template is highlighted and a preview of the database appears in the 'Preview' group.)
Selecting a database template
NOTE: Templates that come with Access 7.0 include: Address Book, Asset Tracking, Book Collection, Expenses, Household Inventory, Order Entry, Recipes, Time and Billing, Video Collection, and so on. Templates have an extension of .MDZ.
d) Click 'OK'. (The File New Database dialog box appears.)
the File New Database dialog box
2) Select the drive where the new database is to be stored from the 'Save in' drop-down list.
3) Select the folder to contain the new database in the 'Save in' list box.
4) Type a name for the new database in the 'File name' drop-down list box.
5) Click 'Create'. (The Database Wizard dialog box appears.)
the Database Wizard dialog box
6) Click 'Next'.
7) (Optional) Customize the tables from the template:
a) Select the table to customize from the 'Table in the database' list box. (The table is highlighted.)
the Tables in the database list box
b) Select the check box in front of the field to be added.
NOTE: The fields that can be customized are shown in italics. The ones that are not shown in italics are required fields and cannot be customized.
the Fields in the table list box
c) Repeat steps 6)a) and 6)b) for each table to be customized.
8) (Optional) Select the 'Yes, include sample data' check box to have some sample data in the new database.
the Yes, include sample data check box
9) Click 'Next'.
10) Select the display style for the fields in the database. (A preview appears.)
Selecting a display style
NOTE: Styles from which to select include: Clouds, Colorful 1, Colorful 2, Dusk, Evergreen, International, Pattern, Standard, and Stone.
11) Click 'Next'.
12) Select the style of printed reports in the database. (A preview appears.)
Selecting style for printed reports
NOTE: Styles from which to select include: Bold, Casual, Compact, Corporate, Formal, and Soft Gray.
13) Click 'Next'.
14) Type the title of the database.
Typing the title of the database
15) (Optional) Include a picture on all printed reports:
a) Select the 'Yes, I'd like a picture on all reports' check box.
the Yes, I'd like to include a picture check box
b) Click 'Picture...'. (The Insert Picture dialog box appears.)
c) Locate the desired picture file.
d) Select the file. (The file is highlighted.)
e) Click 'OK'. (The picture is inserted, and the Database Wizard dialog box reappears.)
Inserting a picture
16) Click 'Next'.
17) (Optional) Select the 'Yes, start the database' check box to start the database automatically after it is created.
the Yes, start the database check box
18) Click 'Finish' to start building the new database. (The Database Wizard displays the status while building the database, and a message pops up when the database has been successfully created.)
19) Click 'OK' to exit the Database Wizard.
NOTE: If the 'Yes, start the database' check box is selected in Step 16), the new database starts automatically. Otherwise, Access displays only the Database Window of the newly created database.
